package com.ningxia.water.mapper;

import com.ningxia.water.entity.TsMeterType;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author hz
 * @since 2021-03-15
 */
public interface TsMeterTypeMapper extends BaseMapper<TsMeterType> {

    @Select("<script>" +
            "SELECT *\n" +
            "FROM ts_meter_info\n" +
            "<where>" +
            "<if test='meter_no!=null'> " +
            "meter_no = #{meter_no} " +
            "</if> " +
            "</where>" +
            "</script>")
    List<TsMeterType> getMeterInfos(Integer meter_no);
}
